/*
 Navicat Premium Data Transfer

 Source Server         : 甄宝线上
 Source Server Type    : MySQL
 Source Server Version : 50728
 Source Host           : rm-bp15m1koq9466l58zko.mysql.rds.aliyuncs.com:3306
 Source Schema         : mall

 Target Server Type    : MySQL
 Target Server Version : 50728
 File Encoding         : 65001

 Date: 19/09/2020 15:09:09
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for zb_module_config
-- ----------------------------
DROP TABLE IF EXISTS `zb_module_config`;
CREATE TABLE `zb_module_config` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `create_time` datetime DEFAULT NULL,
  `creator` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_deleted` bit(1) DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `module_name` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `module_type` int(11) DEFAULT NULL,
  `properties` longtext COLLATE utf8mb4_unicode_ci,
  `timing_content` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `timing_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of zb_module_config
-- ----------------------------
BEGIN;
INSERT INTO `zb_module_config` VALUES (1, '2020-08-11 13:21:43', NULL, b'0', '2020-08-23 15:26:51', '专区广告位', 1, '[{\"moduleType\":\"MODULE_ICON\",\"specType\":\"1002\",\"src\":\"https://resource.s.ahjcwh.com/image/8f01096a117f4747a51b4136213defdb.png\",\"title\":\"一元捡漏\"},{\"moduleType\":\"MODULE_ICON\",\"specType\":\"1002\",\"src\":\"https://resource.s.ahjcwh.com/image/bab0fc99157d4533a43cbc67762c9fb7.png\",\"title\":\"一元捡漏\"}]', NULL, NULL);
INSERT INTO `zb_module_config` VALUES (2, '2020-08-12 14:24:59', NULL, b'0', '2020-09-15 17:19:40', '首页广告位', 0, '{\"goodsId\":3434,\"goodsList\":[{\"afterThumbnail\":\"https://resource.s.ahjcwh.com/image/a44729d0e2ae4e18af51533f740aac08.png\",\"catId\":13,\"thumbnail\":\"https://resource.s.ahjcwh.com/image/cc4e32f09bc34b47a88e32ed03e00782.png\"},{\"afterThumbnail\":\"https://resource.s.ahjcwh.com/image/ce079f0987d343568b3ac1efb72a89eb.png\",\"catId\":2,\"thumbnail\":\"https://resource.s.ahjcwh.com/image/264d1e003c71460b8e13fdf81b90ab4b.png\"},{\"afterThumbnail\":\"https://resource.s.ahjcwh.com/image/71ed97ec18f24437852be85c36956bae.png\",\"catId\":52,\"thumbnail\":\"https://resource.s.ahjcwh.com/image/cc29caf8de434ed08ea55dbe3e9a3718.png\"},{\"afterThumbnail\":\"https://resource.s.ahjcwh.com/image/c1a6529a0b3e4a44ae786a455b913fb9.png\",\"catId\":170,\"thumbnail\":\"https://resource.s.ahjcwh.com/image/2c832077aab74037a667f5c03faa8a84.png\"}],\"moduleType\":\"MODULE_HOME\",\"title\":\"风筝\",\"videoUrl\":\"https://resource.s.ahjcwh.com/image/e6820299a0434c31b00137d167567841.mp4\"}', '', NULL);
INSERT INTO `zb_module_config` VALUES (3, '2020-08-22 10:01:15', NULL, b'0', '2020-09-03 11:41:18', '今日上新', 2, '[{\"link\":\"https://app.s.ahjcwh.com/subject.html\",\"moduleType\":\"MODULE_TODAY_NEW\",\"thumbnail\":\"https://resource.s.ahjcwh.com/image/b85ee1adcb984434bd94e1523b37c4ce.png\",\"title\":\"吊坠\"},{\"link\":\"https://app.s.ahjcwh.com/subject.html\",\"moduleType\":\"MODULE_TODAY_NEW\",\"thumbnail\":\"https://resource.s.ahjcwh.com/image/9c4a488b9ebe451b860e0f2571c4b6b6.png\",\"title\":\"佛公\"},{\"link\":\"https://app.s.ahjcwh.com/subject.html\",\"moduleType\":\"MODULE_TODAY_NEW\",\"thumbnail\":\"https://resource.s.ahjcwh.com/image/17035f5c1e4049e4807e061445e3f391.png\",\"title\":\"项链\"},{\"link\":\"https://app.s.ahjcwh.com/subject.html\",\"moduleType\":\"MODULE_TODAY_NEW\",\"thumbnail\":\"https://resource.s.ahjcwh.com/image/c68f04c3ebb5424faf817e570fafeb57.png\",\"title\":\"戒指\"}]', NULL, NULL);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
